<?php
class Default_Model_DbTable_Region extends Zend_Db_Table_Abstract
{
	protected $_name="hae_bdd_region";
	protected $_primary="id";
	protected $_sequence=true;
	public function getregion($countryId)
	{
	    //Locale
	    $locale = new HAE_Element_Locale();
	    $lang = $locale->getLocale();
		
		$select = $this->select();
		$select->from($this->_name,array('id','name_'.$lang.' AS name','image'));
		$select->where('countryId = ?',$countryId);
		return $this->fetchAll($select);
	}
}
?>